workgroup
Table: workgroup
The workgroup table defines workgroups, their schedules, and assigned locations.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| workgroupId | int(11) | NO | Primary key identifying the workgroup |
| day | varchar(45) | NO | Day of the week or schedule |
| assignedCheckIn | time | NO | Scheduled check-in time |
| assignedCheckOut | time | NO | Scheduled check-out time |
| assignedLocation | int(11) | YES | Assigned location ID |
| laxTime | int(11) | YES | Allowed lateness in minutes |
| workgrouptypeId | int(11) | NO | Reference to workgroup type |
| createdDate | datetime | YES | Record creation timestamp |
| lastEditedDate | datetime | YES | Record last edited timestamp |
Indexes
workgrouptype_fk_idx— Index onworkgrouptypeIdworkgroup_location_fk_idx— Index onassignedLocation
Foreign Key Relations
assignedLocation → location.locationIdworkgrouptypeId → workgrouptype.workgrouptypeId
Usage Notes
- Defines the schedule and assigned locations for each workgroup.
- Supports attendance tracking and field visit planning.